|
JIRA 4.4 : Retrieving the JIRA Administrator
This page last changed on Jul 18, 2011 by rosie@atlassian.com.
On this page: Scenario A: I don't know which user has the JIRA Administrators or JIRA System Administrators global permissionYou first need to find out which group(s) have been granted the global permission.
To find out which group(s) have been granted the JIRA Administrators global permission, run the following database query: select perm_parameter from schemepermissions where PERMISSION=0; select perm_parameter from schemepermissions where PERMISSION=44; select child_name from cwd_membership where parent_name='jira-administrators' If there are no JIRA AdministratorsIf you're using Crowd or an external user management system, there may be no users with administrator permissions.
Scenario B: I know which user has the JIRA Administrators or JIRA System Administrators global permission, but I have forgotten the passwordHere are two different ways you can solve this problem: 1. Send it via emailThis is the recommended approach If you have configured JIRA to send email, just click on the Forgot Password link on the login page, enter your username and click the Send it to me button. You will receive an email which will help you reset your password. 2. Set the password directly in the databaseThis is a last resort only. You can also update the password hash stored for a user in your database. Run the following command to set the user called XXXX's password to the word sphere. update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='XXXX'; Then restart your JIRA instance. Note that this will only work for users in the Internal directory, as otherwise authentication is done externally (eg in an LDAP server). You can find which directory a user belongs to by comparing the directory_id in cwd_user to those in cwd_directory. |
| Document generated by Confluence on Aug 18, 2011 23:28 |